update sinanews 
set geotagcmt = foo.autcmt
FROM
(select sc.newsid, count(cmt.authentic) as autcmt
from sinanews as sc, sinanewscomments as cmt
where sc.newsid = cmt.newsid
group by sc.newsid) as foo
WHERE sinanews.newsid = foo.newsid